Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$PROXY_DATAFILE

This view contains descriptions of datafile and control file backups that are taken with Proxy Copy. Each row represents a backup of one database file.

Column | Datatype | Description
--- | --- | ---
`RECID` | `NUMBER` | Proxy copy record ID
`STAMP` | `NUMBER` | Proxy copy record stamp
`DEVICE_TYPE` | `VARCHAR2(17)` | Type of the device on which the copy resides
`HANDLE` | `VARCHAR2(513)` | Proxy copy handle identifies the copy for restore
`COMMENTS` | `VARCHAR2(81)` | Comment returned by the operating system or storage subsystem. This value is informational only. It is not needed for restore.
`MEDIA` | `VARCHAR2(65)` | Name of the media on which the copy resides. This value is informational only. It is not needed for restore.
`MEDIA_POOL` | `NUMBER` | Media pool in which the copy resides. This is the same value that was entered in the `POOL` operand of the Recovery Manager `BACKUP` command
`TAG` | `VARCHAR2(32)` | Proxy copy tag
`STATUS` | `VARCHAR2(1)` | Indicates the status of the copy: `A` - Object is available `D` - Object is deleted `X` - Object has been "cross-checked" and found not to exist. A subsequent "delete expired" command will change the status to `D`. If, for some reason, the object really does still exist, then a subsequent "cross-check" command will change the status back to `A`.
`DELETED` | `VARCHAR2(3)` | Indicates whether the record has been deleted (`YES`) or not (`NO`)
`FILE#` | `NUMBER` | Absolute datafile number, or 0 if this is a control file backup
`CREATION_CHANGE#` | `NUMBER` | Datafile creation change number
`CREATION_TIME` | `DATE` | Datafile creation Timestamp
`RESETLOGS_CHANGE#` | `NUMBER` | Resetlogs change number of the datafile when the copy was made
`RESETLOGS_TIME` | `DATE` | Resetlogs timestamp of the datafile when the copy was made
`CHECKPOINT_CHANGE#` | `NUMBER` | Checkpoint change number of the datafile when the copy was made
`CHECKPOINT_TIME` | `DATE` | Checkpoint timestamp of the datafile when the copy was made
`ABSOLUTE_FUZZY_CHANGE#` | `NUMBER` | Highest change in any block of the file, if known
`RECOVERY_FUZZY_CHANGE#` | `NUMBER` | Highest change written to the file by media recovery
`RECOVERY_FUZZY_TIME` | `DATE` | Timestamp of the highest change written to the file by media recovery
`INCREMENTAL_LEVEL` | `NUMBER` | If this backup is part of an incremental backup strategy, then 0. Otherwise null.
`ONLINE_FUZZY` | `VARCHAR2(3)` | (`YES`|`NO`) If set to `YES`, this copy was made after a crash or offline immediate (or is a copy of a copy which was taken improperly while the database was open). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent.
`BACKUP_FUZZY` | `VARCHAR2(3)` | (`YES`|`NO`) If set to `YES`, this is a copy taken using the `BEGIN BACKUP | END BACKUP` technique. Note that the `BEGIN BACKUP | END BACKUP` technique is used internally when proxy copies of open files are created. Recovery will need to apply all redo up to the end backup marker to make this copy consistent.
`BLOCKS` | `NUMBER` | Size of the copy (in blocks). Also the size of the datafile when the copy was made.
`BLOCK_SIZE` | `NUMBER` | Block size of the datafile
`OLDEST_OFFLINE_RANGE` | `NUMBER` | If the file number is `0` (that is, this is a control file backup), the RECID of the oldest offline range record in this control file copy. `0` for datafile copies.
`START_TIME` | `DATE` | Starting time
`COMPLETION_TIME` | `DATE` | Completion time
`ELAPSED_SECONDS` | `NUMBER` | Number of elapsed seconds
`CONTROLFILE_TYPE` | `VARCHAR2(1)` | B indicates normal copies S indicates standby copies
`KEEP` | `VARCHAR2(3)` | (`YES`|`NO`) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy
`KEEP_UNTIL` | `DATE` | If `KEEP_UNTIL` is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.
`KEEP_OPTIONS` | `VARCHAR2(10)` | Additional retention options for this backup set: `LOGS` - Logs need to recover this backup are kept `NOLOGS` - Logs needed to recover this backup will not be kept
`RMAN_STATUS_RECID` | `NUMBER` | Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP` | `NUMBER` | Owning `V$RMAN_STATUS` record stamp